/*
    This procedure handles the logic for determining if a user is already a member with an organization.

    NOTE:

    This procedure MUST return either 1 (True) or 0 (False) as a bit data type in a column called
    "IMIS_MEMBER"!
*/
CREATE PROCEDURE [dbo].[BAEBillingMembershipSignupCheck]
    @UserID AS varchar(10)
AS
    DECLARE @IsMember bit;

    SELECT @IsMember = MEMBER_RECORD FROM Name WHERE ID = @UserID;

    -- This is the basic framework for returning a value of 1 or 0 as a column called "IMIS_MEMBER"
    IF (@IsMember = 1)
        BEGIN
            SELECT @IsMember AS 'IMIS_MEMBER';
        END
    ELSE IF (@IsMember = 0)
        BEGIN
            SELECT @IsMember AS 'IMIS_MEMBER';
        END


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON

GO